--CREATING VIEW. CREATE VIEW view_name AS SELECT column1, column2, column3.... FROM table_name WHERE condition;